<?php
$db ['product_sku_map'] = array (
		'columns' => array (
				'map_id' =>
				array (
						'type' => 'int unsigned',
						'required' => true,
						'pkey' => true,
						'extra' => 'auto_increment',
						'editable' => false,
				),
				'bn' => array (
						'type' => 'varchar(30)',
						'required' => true,
						'width' => 85 ,
						'in_list' => true,
						'label' => '货号',
						'default_in_list' => true,
						'filtertype' =>true,
						'filterdefault' => true,
					 'searchtype'=>'has',
				),				
				'sku' => array (
						'type' => 'bigint(20)',
						'required' => true,
						'editable' => false ,
						'in_list' => true,
						'default_in_list' => true,
						'label' => 'sku',
						'filtertype' => 'has',
						'filterdefault' => true,
						'searchtype'=>'has',
				),
				'shop_id' => array (
						 'type' => 'table:shop@ome',
						'required' => true,
						'editable' => false ,
						'in_list' => true,
						'default_in_list' => true,
						'filtertype' => 'yes',
						'filterdefault' => true,		
						'searchtype'=>'has',
     					 'label' => '来源店铺',
				),
				'node_id' => array (
						'type' => 'number',
						'required' => true,
						'editable' => false ,						
						'label' => '节点',
				),
				'addon' => array (
						'type' => 'varchar(200)',
						'editable' => false,
						'in_list' => true,
						'default_in_list' => true,
						'width' => 110,
						'label' => '附加sku参数' 
				)
				,
		),
		
		
		'comment' => '货品对应sku',
		'index' => array (
				'ind_bn' => array (
						'columns' => array (
								0 => 'bn' 
						) 
				) ,
				'ind_sku' => array (
						'columns' => array (
								0 => 'sku'
						)
				)
		),
		'engine' => 'innodb',
		'version' => '$Rev:  $' 
);